DECLARE @sp varchar(200) 
SET @sp = 'AcquireExportJobs' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'BatchDeleteResourceParams' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'BatchDeleteResources' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'BatchDeleteResourceWriteClaims' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'BulkMergeResource' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'BulkReindexResources_2' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'CancelTask' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'CompleteTask' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'CreateExportJob' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'CreateTask_3' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'GetExportJobByHash' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'GetExportJobById' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'GetImportProcessingTaskResult' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'GetNextTask_3' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'GetTaskDetails' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'ReadResource' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'ReindexResource_2' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'ResetTask_2' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'TaskKeepAlive' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'UpdateExportJob' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'UpdateTaskContext' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
SET @sp = 'UpsertResource_7' IF object_id(@sp) IS NOT NULL EXECUTE('DROP PROCEDURE '+@sp)
